2013-04-05 - 5910.200 - Rel Notes - Contracts - Release 018 #BIReleases2013

Release Notes:

‍5910.200 - Contracts - EPM210

Admin Info


Purpose
Including Contract Information in EPM210 - Customer Segment Scorecard
Release No
018
Submitted
04-05-2013
Submitted by
Mallareddy D
Source/Destination Systems
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
Mark Harris
Object(s) Created By
Narendra Koraganji
Object(s) Tested By
Narendra Koraganji

‍Report Name


EPM210 - Customer Segment Scorecard

BEx Query


ZMP_OPASA_Q001
ZMP_OPASA_Q002
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q008
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012

‍NEC Crystal Reports Standards Check


1. EPM210 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM210 NEC CR checklist has been sent to NEC and also attached here for reference:

EPM210 NEC CR Standard Check List.xlsx

Summary Level Check


Test Conducted

Group: North America
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
65,895,548
65,895,548
Pass
2
Last Year Shipped YTD
49,535,432
49,535,432
Pass
3
Current Year Budget YTD
81,480,846
81,480,846
Pass
4
Total Open Revenue
128,132,426
128,132,426
Pass
5
Total Shipped Current Year
194,027,973
194,027,973
Pass
6
Total Shipped Last Year
447,596,834
447,596,834
Pass
7
Total Budget Current Year
516,707,703
516,707,703
Pass
8
TY Quantity
5,913,844
5,913,844
Pass
9
LY Quantity
4,735,464
4,735,464
Pass
10
Budget Quantity
0
0
Pass

Product Mix Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
58,189,876
58,189,876
Pass
2
Open
110,926,270
110,926,270
Pass
3
Total Revenue YTD
169,116,146
169,116,146
Pass
4
Last Year Shipped YTD
49,414,043
49,414,043
Pass
5
Current Year Budget YTD
71,549,289
71,549,289
Pass
6
TY Quantity
5,072,270
5,072,270
Pass
7
LY Quantity
4,726,020
4,726,020
Pass
8
Budget Quantity
0
0
Pass

License Subreport : MLB Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
36,077,617
36,077,617
Pass
2
Open
40,517,831
40,517,831
Pass
3
Total
76,595,447
76,595,447
Pass
4
Last Year
30,673,492
30,673,492
Pass
5
Budget
41,006,366
41,006,366
Pass
6
TY Quantity
3,041,465
3,041,465
Pass
7
LY Quantity
2,539,906
2,539,906
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
15,119,373
15,119,373
Pass
2
Open
27,515,165
27,515,165
Pass
3
Total
42,634,538
42,634,538
Pass
4
Last Year
11,489,793
11,489,793
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,202,231
1,202,231
Pass
7
LY Quantity
931,121
931,121
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
31,047,681
31,047,681
Pass
2
Open
39,696,017
39,696,017
Pass
3
Total
70,743,699
70,743,699
Pass
4
Last Year
28,811,657
28,811,657
Pass
5
Budget
38,980,491
38,980,491
Pass
6
TY Quantity
2,106,764
2,106,764
Pass
7
LY Quantity
2,304,102
2,304,102
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
14,315,104
14,315,104
Pass
2
Open
38,401,326
38,401,326
Pass
3
Total
52,716,430
52,716,430
Pass
4
Last Year
10,890,258
10,890,258
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,880,401
1,880,401
Pass
7
LY Quantity
1,490,916
1,490,916
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
42,158,008
42,158,008
Pass
2
Last Year Shipped MTD
34,323,003
34,323,003
Pass
3
Budget Current Year MTD
0
0
Pass
4
TY Quantity Current Year MTD
3,649,036
3,649,036
Pass
5
LY Quantity Last Year MTD
3,201,655
3,201,655
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

Product Mix Month Subreport : Accessories
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
152,138
152,137.70
Pass
2
Open
0
0
Pass
3
Total Revenue YTD
152,138
152,137.70
Pass
4
Last Year Shipped YTD
47,616
47,615.94
Pass
5
Current Year Budget YTD
64,700
64,700
Pass
6
TY Quantity
12,579
12,579
Pass
7
LY Quantity
4,691
4,691
Pass
8
Budget Quantity
0
0
Pass

License Month Subreport : NBA Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,819,412
4,819,412
Pass
2
Open
170,574
170,574
Pass
3
Total
4,989,986
4,989,986
Pass
4
Last Year
4,152,066
4,152,066
Pass
5
Budget
3,102,811
3,102,811
Pass
6
TY Quantity
410,101
410,101
Pass
7
LY Quantity
362,021
362,021
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : CHAMPS DIVISION
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,746,159
1,746,159
Pass
2
Open
0
0
Pass
3
Total
1,746,159
1,746,159
Pass
4
Last Year
3,015,394
3,015,394
Pass
5
Budget
0
0
Pass
8
TY Quantity
135,758
135,758
Pass
9
LY Quantity
243,398
243,398
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 3930
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
5,589,304
5,589,304
Pass
2
Open
1,775
1,775
Pass
3
Total
5,591,079
5,591,079
Pass
4
Last Year
3,983,225
3,983,225
Pass
5
Budget
7,235,165
7,235,165
Pass
8
TY Quantity
547,081
547,081
Pass
9
LY Quantity
491,967
491,967
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,364,304
4,364,304
Pass
2
Open
13,677
13,677
Pass
3
Total
4,377,982
4,377,982
Pass
4
Last Year
4,253,290
4,253,290
Pass
5
Budget
0
0
Pass
8
TY Quantity
337,462
337,462
Pass
9
LY Quantity
333,224
333,224
Pass
10
Budget Quantity
0
0
Pass

Second Level Check


Test Conducted

Group: North America > TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
680,870
680,870
Pass
2
Last Year Shipped YTD
539,655
539,655
Pass
3
Current Year Budget YTD
0
0
Pass
4
Total Open Revenue
627,637
627,637
Pass
5
Total Shipped Current Year
1,308,508
1,308,508
Pass
6
Total Shipped Last Year
3,085,038
3,085,038
Pass
7
Total Budget Current Year
0
0
Pass
8
TY Quantity
52,743
52,743
Pass
9
LY Quantity
40,523
40,523
Pass
10
Budget Quantity
0
0
Pass

Product Mix Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
678,471
678,471
Pass
2
Open
627,556
627,556
Pass
3
Total
1,306,027
1,306,027
Pass
4
Last Year
538,665
538,665
Pass
5
Budget
0
0
Pass
6
TY Quantity
52,579
52,579
Pass
7
LY Quantity
40,448
40,448
Pass
8
Budget Quantity
0
0
Pass

License Subreport : MLB Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
250,407
250,407
Pass
2
Open
75,638
75,638
Pass
3
Total
326,045
326,045
Pass
4
Last Year
182,960
182,960
Pass
5
Budget
0
0
Pass
6
TY Quantity
17,858
17,858
Pass
7
LY Quantity
12,583
12,583
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : FITTED
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
50,736
50,736
Pass
2
Open
6,980
6,980
Pass
3
Total
57,716
57,716
Pass
4
Last Year
26,175
26,175
Pass
5
Budget
0
0
Pass
6
TY Quantity
4,459
4,459
Pass
7
LY Quantity
2,042
2,042
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
278,712
278,712
Pass
2
Open
98,704
98,704
Pass
3
Total
377,416
377,416
Pass
4
Last Year
225,477
225,477
Pass
5
Budget
0
0
Pass
6
TY Quantity
21,433
21,433
Pass
7
LY Quantity
15,419
15,419
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
319,810
319,810
Pass
2
Open
67,198
67,198
Pass
3
Total
387,009
387,009
Pass
4
Last Year
156,596
156,596
Pass
5
Budget
0
0
Pass
6
TY Quantity
26,238
26,238
Pass
7
LY Quantity
12,297
12,297
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
209,234
209,234
Pass
2
Last Year Shipped MTD
327,394
327,394
Pass
3
Budget Current Year MTD
48,708,540
48,708,540
Pass
4
TY Quantity Current Year MTD
15,479
15,479
Pass
5
LY Quantity Last Year MTD
24,873
24,873
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

Product Mix Month Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
207,134
207,134
Pass
2
Open
2,916
2,916
Pass
3
Total
210.050
210.050
Pass
4
Last Year
327,394
327,394
Pass
5
Budget
0
0
Pass
6
TY Quantity
15,339
15,339
Pass
7
LY Quantity
24,873
24,873
Pass
8
Budget Quantity
0
0
Pass

License Month Subreport : NBA Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
68,631
68,631
Pass
2
Open
2,916
2,916
Pass
3
Total
71,547
71,547
Pass
4
Last Year
99,325
99,325
Pass
5
Budget
0
0
Pass
6
TY Quantity
4,893
4,893
Pass
7
LY Quantity
7,880
7,880
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : PUFFER REDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
13,042
13,042
Pass
2
Open
0
0
Pass
3
Total
13,042
13,042
Pass
4
Last Year
6,003
6,003
Pass
5
Budget
0
0
Pass
8
TY Quantity
846
846
Pass
9
LY Quantity
427
427
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
45,911
45,911
Pass
2
Open
2,916
2,916
Pass
3
Total
48,827
48,827
Pass
4
Last Year
187,605
187,605
Pass
5
Budget
0
0
Pass
8
TY Quantity
3,560
3,560
Pass
9
LY Quantity
14,670
14,670
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
124,992
124,992
Pass
2
Open
0
0
Pass
3
Total
124,992
124,992
Pass
4
Last Year
128,269
128,269
Pass
5
Budget
0
0
Pass
8
TY Quantity
9,325
9,325
Pass
9
LY Quantity
9,987
9,987
Pass
10
Budget Quantity
0
0
Pass

Third Level Check


Test Conducted

Group: North America > TASTEMAKER > United States Sales
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
680,870
680,870
Pass
2
Last Year Shipped YTD
536,737
536,737
Pass
3
Current Year Budget YTD
0
0
Pass
4
Total Open Revenue
627,637
627,637
Pass
5
Total Shipped Current Year
1,308,508
1,308,508
Pass
6
Total Shipped Last Year
3,082,121
3,082,121
Pass
7
Total Budget Current Year
0
0
Pass
8
TY Quantity
52,743
52,743
Pass
9
LY Quantity
40,337
40,337
Pass
10
Budget Quantity
0
0
Pass

Product Mix Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
678,471
678,471
Pass
2
Open
627,556
627,556
Pass
3
Total
1,306,027
1,306,027
Pass
4
Last Year
535,748
535,748
Pass
5
Budget
0
0
Pass
6
TY Quantity
52,579
52,579
Pass
7
LY Quantity
40,262
40,262
Pass
8
Budget Quantity
0
0
Pass

License Subreport : MLB Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
250,407
250,407
Pass
2
Open
75,638
75,638
Pass
3
Total
326,045
326,045
Pass
4
Last Year
182,960
182,960
Pass
5
Budget
0
0
Pass
6
TY Quantity
17,858
17,858
Pass
7
LY Quantity
12,583
12,583
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : FITTED
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
50,736
50,736
Pass
2
Open
6,980
6,980
Pass
3
Total
57,716
57,716
Pass
4
Last Year
26,175
26,175
Pass
5
Budget
0
0
Pass
6
TY Quantity
4,459
4,459
Pass
7
LY Quantity
2,042
2,042
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
278,712
278,712
Pass
2
Open
98,704
98,704
Pass
3
Total
377,416
377,416
Pass
4
Last Year
225,477
225,477
Pass
5
Budget
0
0
Pass
6
TY Quantity
21,433
21,433
Pass
7
LY Quantity
15,419
15,419
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
319,810
319,810
Pass
2
Open
67,198
67,198
Pass
3
Total
387,009
387,009
Pass
4
Last Year
156,596
156,596
Pass
5
Budget
0
0
Pass
6
TY Quantity
26,238
26,238
Pass
7
LY Quantity
12,297
12,297
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
209,234
209,234
Pass
2
Last Year Shipped MTD
324,476
324,476
Pass
3
Budget Current Year MTD
0
0
Pass
4
TY Quantity Current Year MTD
15,479
15,479
Pass
5
LY Quantity Last Year MTD
24,687
24,687
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

Product Mix Month Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
207,134
207,134
Pass
2
Open
2.916
2,916
Pass
3
Total
210,050
210,050
Pass
4
Last Year
324.476
324.476
Pass
5
Budget
0
0
Pass
8
TY Quantity
15,339
15,339
Pass
9
LY Quantity
24,687
24,687
Pass
10
Budget Quantity
0
0
Pass

License Month Subreport : NBA Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
68,631
68,631
Pass
2
Open
2,916
2,916
Pass
3
Total
71,547
71,547
Pass
4
Last Year
99,325
99,325
Pass
5
Budget
0
0
Pass
6
TY Quantity
4,893
4,893
Pass
7
LY Quantity
7,880
7,880
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : Others
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
12,221
12,221
Pass
2
Open
0
0
Pass
3
Total
12,221
12,221
Pass
4
Last Year
58,132
58,132
Pass
5
Budget
0
0
Pass
8
TY Quantity
1,212
1,212
Pass
9
LY Quantity
4,617
4,617
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
45,911
45,911
Pass
2
Open
2,916
2,916
Pass
3
Total
48,827
48,827
Pass
4
Last Year
184,687
184,687
Pass
5
Budget
0
0
Pass
8
TY Quantity
3,560
3,560
Pass
9
LY Quantity
14,484
14,484
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
124,992
124,992
Pass
2
Open
0
0
Pass
3
Total
124,992
124,992
Pass
4
Last Year
128,269
128,269
Pass
5
Budget
0
0
Pass
8
TY Quantity
9,325
9,325
Pass
9
LY Quantity
9,987
9,987
Pass
10
Budget Quantity
0
0
Pass

Reference Document(Specification)


2013-03-15 - 5910.200 - Spec - Contract Reports